package com.minedata.authorization.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.minedata.authorization.bean.ModuleBean;

public interface ModuleMapper {
	@Select("SELECT e.* FROM t_user_role b LEFT JOIN t_role c ON b.roleId = c.id LEFT JOIN t_role_module d ON C.id = d.roleId LEFT JOIN t_module e ON d.moduleid = e.id WHERE b.userId=#{userId}")
	public List<ModuleBean> findModuleByUserId(Integer userId);
}
